insert overwrite table yl_ods.yl_lmdm_sys_customer partition(dt)
select
id
,code
,name
,abbreviation
,industry_id
,type_id
,country_id
,country_code
,province_id
,city_id
,area_id
,null as address
,is_enable
,is_delete
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,version
,sort
,nature_id
,main_deposit
,null as contact_name
,null as contact_mobile
,null as contact_email
,null as financial_name
,null as financial_mobile
,null as financial_email
,zip_code
,null as id_card_number
,null as unified_credit_code
,null as organization_code
,tax_registration_code
,business_registration_code
,business_license_img_url
,organization_img_url
,tax_registration_img_url
,id_card_front_img_url
,id_card_back_img_url
,network_id
,staff_id
,null as staff_mobile
,customer_level_id
,is_vip_account
,credit_amount
,is_open_cod
,single_cod_limit
,rebate_period_id
,null as cc_stt_bank_name
,null as cc_stt_bank_account
,null as cc_stt_bank_account_name
,bill_id
,null as bill_emial
,settlement_id
,customer_share_id
,pay_id
,prompt
,invoice_id
,null as taxpayer_name
,null as taxpayer_number
,null as taxpayer_registration_address
,null as taxpayer_phone
,null as taxpayer_bank_name
,null as taxpayer_bank_account
,null as invoice_recipient_name
,null as invoice_recipient_phone
,null as invoice_recipient_email
,null as invoice_recipient_address
,source_id
,mall_id
,mall_name
,parent_customer
,meter_bubble
,parent_id
,billing_day
,account_period_id
,quote_id
,ess_object
,billing_weight
,is_max_weight
,is_business_parcel tiny
,share_enable tiny
,printer_equipment_number
,printer_equipment_manufacturer tiny
,printer_applet_qr_img_path
,card_type tiny
,attribute_id
,recalc_cost_flag tiny
,is_receipt_flag tiny
,receipt_fee
,settle_customer_code
,market_staff_code
,category_primary_id
,category_primary_name
,category_first_id
,category_first_name
,category_second_id
,category_second_name
,deductions_mode tiny
,is_show_app small
,dt
from jms_ods.yl_lmdm_sys_customer
where dt = '{{ execution_date | cst_ds }}' ;